Release 10.1A: OpenEdge Data Management:
DataServer for ODBC

Modifying tables to support case-insensitive indexes

You can use case-insensitive indexes with an ODBC data source, after making certain changes to your data-source table.

To modify tables to support case-insensitive indexes:

Add a column of the same data type before the indexed column. The new column must immediately precede the indexed column.
Name the column _S#_column1.

For example, if your table has an indexed column named emp_id, name the new column _S#_emp_id. The new column accommodates the uppercase version of the index.

Set the _S#_ column to the uppercase value of the original column.
Re-create the index with the _S#_ column as a component in place of the original column.
If you have already created your schema holder, update it to reflect your changes to the data-source table.
Note: For Informix case-insensitive indexes, provide "_S__ (underscore followed by "S" followed by two "_") instead of "_S#_" (underscore followed by "S" followed by number sign followed by underscore).